SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweinscripciones
AS
SELECT     idInscripcion AS ID, Alumno, AnioLectivo, Organizacion, Carrera, Curso, Escolarizado, Resuelta, U_Educativa, AbanderadoEscolta, TieneHermanos, 
                      PadresEnLaInstitucion, Turno, Baja, CausaBaja, EtapaInscripcion, Nivel, OrganiazacionOrigen
FROM         dbo.tb_Inscripciones
GO
GRANT SELECT ON  [dbo].[vweinscripciones] TO [Alumnos]
GRANT INSERT ON  [dbo].[vweinscripciones] TO [Alumnos]
GRANT DELETE ON  [dbo].[vweinscripciones] TO [Alumnos]
GRANT UPDATE ON  [dbo].[vweinscripciones] TO [Alumnos]
GRANT SELECT ON  [dbo].[vweinscripciones] TO [Coordinaciones]
GRANT INSERT ON  [dbo].[vweinscripciones] TO [Coordinaciones]
GRANT DELETE ON  [dbo].[vweinscripciones] TO [Coordinaciones]
GRANT UPDATE ON  [dbo].[vweinscripciones] TO [Coordinaciones]
GRANT SELECT ON  [dbo].[vweinscripciones] TO [SoloVer]
GO
